#pragma once
#include <afxdb.h> 
#include <odbcinst.h>
#include "myfunction.h"

struct SalsInfo
{
	int nRecordNum;
	char szCustomLabel[50];
	char szUserId[30];
	char szFullName[50];
	char szPhone[50];
	char szEmail[50];
	char szAddress1[50];
	char szAddress2[50];
	char szCity[50];
	char szState[50];
	char szZip[20];
	char szCountry[50];
	float fSalePrice;
	float fShappingHanding;
	float fTax;
	float fInsurance;
	float fTotalPrice;
	int	nPaymentmethod;
};

class CReadWriteCSV
{
public:
	CReadWriteCSV();
	~CReadWriteCSV();
	CString GetExcelDriver();
	void ReadFromExcel();
	void WriteToExcel();
	CString GetCsvDriver();
	void ReadFromCSV();
	void setFilePath(char*spath);
	CString m_sPath;
	
	LRunSql m_runsql;
};